Flexible queries in relational databases
نویسندگان
چکیده
Allowing for flexible queries enables database users to express preferences inside minimal requirements, and, if necessary, priorities inside compound queries. In other words, clear-cut properties can be refined by ordering the interpretations compatible with them, according to user's preferences. Often the representation of these preferences can be viewed as modelling linguistic-like terms in requests. In this paper, the theoretical issues raised by the introduction of flexible queries are studied in the case of the division operator, in the framework of fuzzy sets and possibility theory. The notion of division is well-known in the context of regular relations and the extension of this operation to fuzzy relations (induced by the flexible queries) is investigated. Several types of extended divisions can be envisaged, depending on the meaning of the grades attached to the tuples of the fuzzy relations (degree of fulfillment of gradual properties, level of importance of components in a query, or uncertainty pervading data). We focus on the first two meanings which are associated with different multiple-valued logic implications and we examine their properties and their expression in the framework of an extended SQL-like language where no specific construct for the division is available.
منابع مشابه
Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملRelational Databases Query Optimization using Hybrid Evolutionary Algorithm
Optimizing the database queries is one of hard research problems. Exhaustive search techniques like dynamic programming is suitable for queries with a few relations, but by increasing the number of relations in query, much use of memory and processing is needed, and the use of these methods is not suitable, so we have to use random and evolutionary methods. The use of evolutionary methods, beca...
متن کاملIntroducing the aggregate "count" into flexible queries
Flexible querying aims at expressing preferences inside queries instead of strict requirements. We consider ordinary relational databases and flexible querying calling on fuzzy sets. The topic of this paper is to define new types of flexible conditions : the ones involving the count operator. The main difficulty is to handle cardinalities of fuzzy sets. keywords : databases, flexible querying, ...
متن کاملHow to Achieve Fuzzy Relational Databases Managing Fuzzy Data and Metadata
Fuzzy relational databases have been introduced to deal with uncertain or incomplete information demonstrating the efficiency of processing fuzzy queries. For these reasons, many organizations aim to integrate flexible querying to handle imprecise data or to use fuzzy data mining tools, minimizing the transformation costs. The best solution is to offer a smooth migration towards this technology...
متن کاملFlexible Retrieval of X-Ray Images Based on Shape Descriptors Using a Fuzzy Object-Relational Database
This paper presents a novel approach for medical image storage using a Fuzzy Object-Relational Database Management System (FORDBMS). The system stores medical images along with a set of parameters describing their content. Flexible queries can be performed over these parameters to retrieve images matching visually. To illustrate the capabilities of the FORDBMS, parameter curves are obtained fro...
متن کامل